UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJ4CpbArTBGyceKjDuo8VMSHUY/R1WjKf65R+n04dRg='
WHERE
key_id = '0b0b2321bb61fdbb2531bdbedeae26fb6437d33cac8be04421219ca799fb7f27'
AND (
token = 'nJ4CpbArTBGyceKjDuo8VMSHUY/R1WjKf65R+n04dRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)