UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2lJhp3JCZLVhncIxO3mb1HgDuXWRMs5gJfOa7qR0CY='
WHERE
key_id = '1fad2b6e823a0fa64effd6d10a1608677adf2f44952061aa66fafae61f367b64'
AND (
token = 'z2lJhp3JCZLVhncIxO3mb1HgDuXWRMs5gJfOa7qR0CY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)