UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQ8iercOk5YD8X5Ss5ROct7ibvSPHCTJdWPZkYQowsk='
WHERE
key_id = '7042add6b144ebc1f0e9b724a16571c7fff4ccf83a078eaaf115a840ee77ec5c'
AND (
token = 'LQ8iercOk5YD8X5Ss5ROct7ibvSPHCTJdWPZkYQowsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)