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