UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgVG4+rCpi91y9lVlPGW4eyro4Ule4xx4Tx6zeAA/4U='
WHERE
key_id = '1e23cfa7c637ce57277be52ef4e5ce42efd148871c03b364ef7ba898d16b749c'
AND (
token = 'lgVG4+rCpi91y9lVlPGW4eyro4Ule4xx4Tx6zeAA/4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)