UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aSn/1yYMJvw/TSc/uGr6o6PGJh52wa5U5zIpKO/fNVw='
WHERE
key_id = 'c58c46202fc236ffca10edddf46d899ac3dd1b68ce7dd45f5d468fe7aa76a314'
AND (
token = 'aSn/1yYMJvw/TSc/uGr6o6PGJh52wa5U5zIpKO/fNVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)