UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LROPn1yG7D7Bb8l9R6kWRhsEM/f3H9dZ2M0jMT6bDo0='
WHERE
key_id = 'e0993d28dd80d4d55ef7f8b21a313ce5581daff7a246cfa84316cf68f1c03eb5'
AND (
token = 'LROPn1yG7D7Bb8l9R6kWRhsEM/f3H9dZ2M0jMT6bDo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)