UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tf6UCAm8LMxNbff0uzRunrlj9C6mdMoydSFtdz4TNgw='
WHERE
key_id = 'b0ceb84358c03cceee3753bd883e757da1e479701bed5385d4cb848336ac49a2'
AND (
token = 'tf6UCAm8LMxNbff0uzRunrlj9C6mdMoydSFtdz4TNgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)