UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3CpOVPmSYmcRwgVSZeOMEMfgV6ued2BJNbNXwnvS4VE='
WHERE
key_id = '5c19f4813818785c2007cbebd8d3df7969ae316f9345c1db802423240a180b6d'
AND (
token = '3CpOVPmSYmcRwgVSZeOMEMfgV6ued2BJNbNXwnvS4VE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)