UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vhquJr2lfm74wzmCMPGWCKyozXejM/f6mDLktEe9V8o='
WHERE
key_id = 'baccc12d5b6e0d5df6c09721a3e7f3f7eb4702756dbaa8d103e9ea484b39c80a'
AND (
token = 'vhquJr2lfm74wzmCMPGWCKyozXejM/f6mDLktEe9V8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)