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