UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LSNcH6HEj1Mt+1+JGg5TWFNFrqtzv2Z/OJBB9dZPhUs='
WHERE
key_id = 'f3fa87fee15cd1afc1801815d2e5470c2614b2326bd13af6c1383af682a6ceb9'
AND (
token = 'LSNcH6HEj1Mt+1+JGg5TWFNFrqtzv2Z/OJBB9dZPhUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)