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