UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Uz0VHdTvKncOpcCEXtBoIOAd0rauY9+tS832kv97Xug='
WHERE
key_id = 'c7f6faeb924f1393cc41448d069482b88f8c1df355f70dcb64c91e96da63489f'
AND (
token = 'Uz0VHdTvKncOpcCEXtBoIOAd0rauY9+tS832kv97Xug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)