UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z897K9nBDhAk8e7Xyt3qTNEUKr3PmZYmP4q29TWXQZw='
WHERE
key_id = 'cfe28228384399d274ea98e83bf42d2d0ea5062a0ae0f54497a6d351a5b25f20'
AND (
token = 'Z897K9nBDhAk8e7Xyt3qTNEUKr3PmZYmP4q29TWXQZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)