UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3v2iQYVxoekGNug358pVA47OPPv77E9cgyEVbHeiAH4='
WHERE
key_id = 'b74210b81f9c3525546bf3a6b03695527d6644a952c471ffb65a1f0649647b14'
AND (
token = '3v2iQYVxoekGNug358pVA47OPPv77E9cgyEVbHeiAH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)