UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apN9CLHWS+DezBVpSdx2Y7x78N1InEMTH11SgqqjpN4='
WHERE
key_id = '427716874bbd5cdb1a4fbc111817fa4196df865ceef2cd931eae5a0273662b8d'
AND (
token = 'apN9CLHWS+DezBVpSdx2Y7x78N1InEMTH11SgqqjpN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)