UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXp762ZmIKc+d0Ul+Ld+XRzFgRyOxaa5eewRrH5IcL4='
WHERE
key_id = 'd0af9b25e07033bb9bf76a2777b0bfae2b2111a80ffdbf53a141df56a0ee7177'
AND (
token = 'nXp762ZmIKc+d0Ul+Ld+XRzFgRyOxaa5eewRrH5IcL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)