UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WGhBGwZ15XX1ycK0arBcmPnm7BCtw0IGOYFqx3vMtyc='
WHERE
key_id = '7ffecef3e80ac977fce06ef4394dc34c4b464886b601a5eef2a2555b34c543f6'
AND (
token = 'WGhBGwZ15XX1ycK0arBcmPnm7BCtw0IGOYFqx3vMtyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)