UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mipsqFHLk8GNzVQyRV8+NCVsvMkEQkef0HHejOz9e2c='
WHERE
key_id = '596822e98ae1fdc4a81a1460531379da6b9527d93c21d5aa2f4ae0dd72e5c348'
AND (
token = 'mipsqFHLk8GNzVQyRV8+NCVsvMkEQkef0HHejOz9e2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)