UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yTCkHyLBIv6MQh36v6u4wzBSnFIrZqXxbjT80UxHMcg='
WHERE
key_id = 'dfeb2db12f6e046fb7276bc9f7de688da1e5b81ee12da74a2072768a9da6f78e'
AND (
token = 'yTCkHyLBIv6MQh36v6u4wzBSnFIrZqXxbjT80UxHMcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)