UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aLv3V+Bo+6pFiwcN6wvQ3nHy3lqZaun9AyO5iHIjRU4='
WHERE
key_id = '462fabdee34c1876a78f888f7706eee9f92b2ef1f7f74b27d7c341909a4f4c3d'
AND (
token = 'aLv3V+Bo+6pFiwcN6wvQ3nHy3lqZaun9AyO5iHIjRU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)