UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDtiAICMjyu+4vn3JTkDdrP9UdwNZb7FuKXKsA1p1w8='
WHERE
key_id = '912f8e0a7b0b2f6f37f280bf4bbce5c3b2f7032144111e9fbad6303eab7bd88e'
AND (
token = 'hDtiAICMjyu+4vn3JTkDdrP9UdwNZb7FuKXKsA1p1w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)