UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4A6OlVavaZKWpwzHd++sQFd3HkeXshcqZZD5qkB68ok='
WHERE
key_id = '782bd88016b35c9c40ca98387be30d233ec46ce15bc628a1052c58d25a5f3342'
AND (
token = '4A6OlVavaZKWpwzHd++sQFd3HkeXshcqZZD5qkB68ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)