UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9dgvdwcYtwYy8nNZX6QUtHv380UTUs/dUeV2dNsdaE='
WHERE
key_id = '5a82019890acc6cc53b6d3a1a97dc1f1a34bd360aaabe886c739041ce8cad6ce'
AND (
token = 'b9dgvdwcYtwYy8nNZX6QUtHv380UTUs/dUeV2dNsdaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)