UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2YjdtdSqkRVyCc7EyD91qHcfDZs5A4DQepwZ37e9hZk='
WHERE
key_id = '8f9de27cd492a0f3feb4cc068caa1f0514cc36dd5bb2136ed2f9a1127a81c997'
AND (
token = '2YjdtdSqkRVyCc7EyD91qHcfDZs5A4DQepwZ37e9hZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)