UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0yq6qg+twW9t40FAcxfiEOi6R0zNrdULTzMueZKPsAI='
WHERE
key_id = '2e1ea6bc1bb1bb70b99f1bf656a4136e26a700972a5a129a316487667d2d41e0'
AND (
token = '0yq6qg+twW9t40FAcxfiEOi6R0zNrdULTzMueZKPsAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)