UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/kP61MUjJgFRJRTDX0ROm5Bw2mfvFuEuX8SrWi8LetI='
WHERE
key_id = '6367754f040367b05e474ca139aac6dba92b2eb2345096a8b992d163a12a75e2'
AND (
token = '/kP61MUjJgFRJRTDX0ROm5Bw2mfvFuEuX8SrWi8LetI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)