UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wiFzB7lTDLoFBiyo7AZnkRmGstAekjNeJ5VYnFQZY0w='
WHERE
key_id = '27501a1c12a6e52d044d33c2418a75127d82b3bfdc8684986e819450373328d2'
AND (
token = 'wiFzB7lTDLoFBiyo7AZnkRmGstAekjNeJ5VYnFQZY0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)