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