UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'he1cxGS8dWvVjk55nu9ulwCMeZnzNhBhJGDax5KkWDE='
WHERE
key_id = '730857f6fd3484d045ff04b00109aa7f5a891d28bce345b284abfb263288912f'
AND (
token = 'he1cxGS8dWvVjk55nu9ulwCMeZnzNhBhJGDax5KkWDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)