UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rF6ixG5YNjSqGKWndPgna82972UwNdU+brRj2L9lRP0='
WHERE
key_id = 'ac93e119ab22269aa7ddb7fb21fca7b2f36dc98b0efe07103dfdeb0d9f060b97'
AND (
token = 'rF6ixG5YNjSqGKWndPgna82972UwNdU+brRj2L9lRP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)