UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xMSSFCeeP+favXvTNYTO6xDkh01kgTQEN8RVg9NFjj4='
WHERE
key_id = '01d42c3b26b5e08217faf14486c7c3b55ad1c545c6a4ed01bcca783a8f4cab5a'
AND (
token = 'xMSSFCeeP+favXvTNYTO6xDkh01kgTQEN8RVg9NFjj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)