UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SnsPpIIgUY0jLCLiwaPNF6vF46gUPjMrznXV3qx5RWk='
WHERE
key_id = 'b86506f43404bf3882c8a755356362156327fdfcfc115558a816e89477aecedf'
AND (
token = 'SnsPpIIgUY0jLCLiwaPNF6vF46gUPjMrznXV3qx5RWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)