UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gyyZjhoLIW3XO78PjtjrFW1xT98yIN1uK52YO6jZCAc='
WHERE
key_id = '7487346a1d2b3952c48851d66b1bbc6548248d18504f94f822859935cef7ecae'
AND (
token = 'gyyZjhoLIW3XO78PjtjrFW1xT98yIN1uK52YO6jZCAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)