UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VdnUP3c0npAunQ6+qOpXgSRi5GJwvNRR2bVFtz6wmlg='
WHERE
key_id = 'b4447f40dcea9ffea898724e6dca7505ca418693594eb3b716efe265bbcbc37d'
AND (
token = 'VdnUP3c0npAunQ6+qOpXgSRi5GJwvNRR2bVFtz6wmlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)