UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jg+70Ua5DB5PncexDjZ5a16JdGlTKjyciZfoOq7YPYE='
WHERE
key_id = 'a7c984bae2146b70b734a782b02df3eca372a4ed0c8c7dbfad560fc3682ee805'
AND (
token = 'Jg+70Ua5DB5PncexDjZ5a16JdGlTKjyciZfoOq7YPYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)