UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+c9ClfWPWnoKCICdsbUuH2wEQsRS9i+kpdQACei3VSw='
WHERE
key_id = 'c86128e4c63aa6a07345978f7159b81148349eab948d0c1cf2eb6c528e1b62dc'
AND (
token = '+c9ClfWPWnoKCICdsbUuH2wEQsRS9i+kpdQACei3VSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)