UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3RzVcvSIoYR6kDWYW2CrkB2BvvWwpU7MwxB2N7Rbu4Q='
WHERE
key_id = 'ca5bce693b5a722041731cf3226d28b48895336ad44a050bdb856a08f74b4945'
AND (
token = '3RzVcvSIoYR6kDWYW2CrkB2BvvWwpU7MwxB2N7Rbu4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)