UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ypY8DbjsVh8xoTfoKa4uBu/uBmoGooKp2D8lSKb8DEY='
WHERE
key_id = '1ed2eb48e42231ee50eccba1bf35df909cdcf14cff28c4a099bed9227a26f14f'
AND (
token = 'ypY8DbjsVh8xoTfoKa4uBu/uBmoGooKp2D8lSKb8DEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)