UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvbnEe33OcndILNBisUajTp4KdpA2TvLREb+dyp2DlU='
WHERE
key_id = '93f71e1a516089158eac91620749c4cfa3ee029c35658fcfb0210bae4dc968a7'
AND (
token = 'zvbnEe33OcndILNBisUajTp4KdpA2TvLREb+dyp2DlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)